<!doctype HTML public "-//W3C//DTD HTML 4.0 Frameset//EN">
<html>
<head>
<meta http-equiv="content-type" content="text/html; charset=utf-8">
<meta name="generator" content="Adobe RoboHelp - www.adobe.com">
<title>About derived metrics</title>
<link rel="stylesheet" href="userhelp_ns.css"><script type="text/javascript" language="JavaScript" title="WebHelpSplitCss">
<!--
if (navigator.appName !="Netscape")
{   document.write("<link rel='stylesheet' href='userhelp.css'>");}
//-->
</script>
<style type="text/css">
<!--
p.whs1 { margin-left:0px; }
ul.whs2 { list-style:disc; }
img_whs3 { border:none; width:17px; height:17px; float:none; border-style:none; }
-->
</style><script type="text/javascript" language="JavaScript">
<!--
if ((navigator.appName == "Netscape") && (parseInt(navigator.appVersion) == 4))
{
  var strNSS = "<style type='text/css'>";
  strNSS += "p.whs1 {margin-left:1pt; }";
  strNSS +="</style>";
  document.write(strNSS);
}
//-->
</script>
<script type="text/javascript" language="JavaScript" title="WebHelpInlineScript">
<!--
function reDo() {
  if (innerWidth != origWidth || innerHeight != origHeight)
     location.reload();
}
if ((parseInt(navigator.appVersion) == 4) && (navigator.appName == "Netscape")) {
	origWidth = innerWidth;
	origHeight = innerHeight;
	onresize = reDo;
}
onerror = null; 
//-->
</script>
<style type="text/css">
<!--
div.WebHelpPopupMenu { position:absolute; left:0px; top:0px; z-index:4; visibility:hidden; }
-->
</style><script type="text/javascript" language="javascript1.2" src="whmsg.js"></script>
<script type="text/javascript" language="javascript" src="whver.js"></script>
<script type="text/javascript" language="javascript1.2" src="whproxy.js"></script>
<script type="text/javascript" language="javascript1.2" src="whutils.js"></script>
<script type="text/javascript" language="javascript1.2" src="whlang.js"></script>
<script type="text/javascript" language="javascript1.2" src="whtopic.js"></script>
</head>
<body><script type="text/javascript" language="javascript1.2">
<!--
if (window.gbWhTopic)
{
	if (window.addTocInfo)
	{
	addTocInfo("Analyzing report and document results\nCalculating data on a report: Metrics\nCreating a metric based on existing metrics: Derived metrics\nAbout derived metrics");
addButton("show",BTN_TEXT,"Show","","","","",0,0,"","","");

	}
	if (window.writeBtnStyle)
		writeBtnStyle();

	if (window.writeIntopicBar)
		writeIntopicBar(1);

	if(1)
	{
	
	}

	if (window.setRelStartPage)
	{
	setRelStartPage("MicroStrategy_Web_Help.htm");

		autoSync(1);
		sendSyncInfo();
		sendAveInfoOut();
	}
}
else
	if (window.gbIE4)
		document.location.reload();

//-->
</script>
<h1>About derived metrics</h1>
<p>You can create a new metric while you are viewing a report. For example, 
 you can subtract the values of one metric from the values of another metric, 
 such as Revenue Forecast - Revenue. You can calculate a monthly average, 
 for example, Yearly Profit / 12. If the report shows the dollar sales 
 for a particular region, you can create a derived metric to view the same 
 data in millions, defined as Dollar Sales/1,000,000.</p>
<p>Derived metrics are metrics that a report analyst can create based on 
 existing metrics on the report. A derived metric performs a calculation 
 on the fly with the data available on a report, without re-executing the 
 report against the data source. Derived metrics are not metric objects 
 that can be re-used in other MicroStrategy reports and documents. They 
 are metrics that are saved and displayed only on the specific report on 
 which they are created.</p>
<p class=TopicTextBulleted>You can only use metrics already existing in 
 a report to create a derived metric. If the derived metric requires data 
 not available on the report or in the Report Objects panel, the report 
 must be re-executed against your data source before the new data is displayed.</p>
<p class=TopicTextBulleted>Derived metrics can also be created in Report 
 Services documents. See 
<a HREF="Creating_derived_metrics_documents.htm">Creating 
 derived metrics in documents</a>.</p>
<h2>Prerequisites</h2>
<ul>
<li class=p-TopicTextBulleted><p class=TopicTextBulleted>You must have 
 MicroStrategy OLAP Services to create derived metrics. To evaluate OLAP 
 Services, contact your MicroStrategy Account Executive or email MicroStrategy 
 directly at 
<a href="mailto:info@microstrategy.com">info@microstrategy.com</a>. 
 &nbsp;</p></li>
	
<li class=p-TopicTextBulleted><p class=TopicTextBulleted>You must have 
 the necessary privileges to add or remove metrics and calculations. </p></li>
	
<li class=p-TopicTextBulleted><p class=TopicTextBulleted>You must have 
 DHTML enabled. See 
<a href="DHTML-only_features_in_Web.htm">Enabling DHTML 
 in Web</a>.</p></li>
</ul>
<h2>To create a derived metric on a report</h2>
<ol class=whs2 style="list-style: decimal;" type=1>
	
<li class=p><p class="whs1">Click the name of a report 
 to execute it. The report must be in either Grid view or Grid and Graph 
 view.</p></li>
	
<li class=p><p>From the <span style="font-weight: bold;"><B>Data</B></span> 
 menu, select <span style="font-weight: bold;"><B><b>Insert New Metric</b></B></span>. 
 The Insert New Metric dialog box opens.</p></li>
	<ul type="disc" class="whs2">
		
<li class=p><p>If DHTML is disabled, click the <span style="font-weight: bold;"><B><b>Go</b></B></span> 
 check mark. </p></li>
	</ul>
	
<li class=p><p>Select <span style="font-weight: bold;"><B>New metric </B></span>in 
 the <span style="font-weight: bold;"><B>Object</B></span> drop-down list. </p></li>
	
<li class=p><p>In the <span style="font-weight: bold;"><B>Name</B></span> 
 field, type the name of the new metric. </p></li>
	
<li class=p><p>In the <span style="font-weight: bold;"><B>Definition</B></span> 
 field, type the formula to designate how the metric should be calculated. 
 For example, type [Revenue]/[Profit].</p></li>
</ol>
<ul><ul>
<li style="list-style: disc;" type=disc class=p><p>When using another 
 metric with spaces or special characters in its name, place the name within 
 brackets [ ]. For example, [$ Sales]. </p></li>
		
<li style="list-style: disc;" type=disc class=p><p>You may use 
 arithmetic operators and parentheses in the formula. For example, the 
 formula for a derived metric called Profit may be [$ Sales] - Cost </p></li>
	</ul>
</ul>
<ul class=whs2 style="list-style: decimal;" type=1>
	<ul type="disc" class="whs2">
		
<li class=p><p>If DHTML is enabled, you can select a metric from 
 the <span style="font-weight: bold;"><B>Available</B></span> list and add it 
 to the Definition area. </p></li>
	</ul>
</ul>
<ol class=whs2 start=6 style="list-style: decimal;" type=1>
	
<li class=p><p class="whs1">To create a more advanced 
 derived metric, for example, Running Sum of Revenue or Average of Daily 
 Website Hit Counts, you can define the metric based on a function. To 
 access a list of functions you can use, click the <span style="font-weight: bold;"><B>Function 
 Wizard</B></span> icon <img src="images/functionwizard.gif" x-maintain-ratio="TRUE" width="17px" height="17px" border="0" class="img_whs3"> before adding anything to the Definition pane. For 
 steps to use functions to insert new metrics, refer to 
<a HREF="Derived_metric_using_function.htm">Creating 
 a derived metric using a function</a>.</p></li>
	
<li class=p><p>Click <span style="font-weight: bold;"><B>OK</B></span> to 
 create the new metric.</p></li>
</ol>
<h3>Related topic</h3>
<ul type="disc" class="whs2">
	
<li class=p><p>
<a HREF="Derived_metric_using_function.htm">Creating 
 a derived metric using a function</a></p></li>
</ul>
<p class=TopicTextBulleted>&nbsp;</p>
<script type="text/javascript" language="javascript1.2">
<!--
highlightSearch();
if (window.writeIntopicBar)
	writeIntopicBar(0);
if(0)
{

}
//-->
</script>
</body>
</html>
